# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月14日
"""
import pandas as pd

path = '../数据文件/课件030-031/数据.xlsx'

data = pd.read_excel(path)

def BMI(data):
	ht = data['身高']
	wt = data['体重']
	BMI= wt/ht**2
	return BMI

data['BMI'] = data.apply(BMI, axis=1)

print(data)
